package com.wskj.insuranceweb.reporter.mapper;

import com.wskj.insuranceweb.reporter.pojo.Findings;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Mapper
@Repository
public interface FindingMapper {
    @Insert("insert into findings values(seq_finding.nextval,#{customernumber},#{findings})")
    void addFindings(Findings findings);
    @Select("select * from findings where customernumber = #{0}")
    Findings getFinding(String cust);
}
